<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>NetApp Node Capacity Forecast and Trends</staticValue></dataSource></textItem><textItem><dataSource><staticValue> For </staticValue></dataSource><conditionalRender refVariable="showLabel"><renderFor refVariableValue="1"/></conditionalRender></textItem><textItem><dataSource><reportExpression>ParamDisplayValue('sArray')</reportExpression></dataSource><conditionalRender refVariable="showLabel"><renderFor refVariableValue="1"/></conditionalRender><style><CSS value="background-color:#FFFFCC"/></style></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Overall Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Overall Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Current for Report"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Provisioned</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Overall Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Provisioned (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Available</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Overall Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Free Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Forecast</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Next 12 Months)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart13" refQuery="Storage Forecast">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd/yy)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#66CCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Usable (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Forecast Usable (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Forecast Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:650px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_notes><v2_note refQuery="Storage Forecast"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Current Used: </staticValue></dataSource></v2_chartTextItem><v2_chartTextItem><dataSource><dataItemValue refDataItem="Current for Report"/></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_bottom offset="80px"/></v2_verticalPosition><v2_horizontalPosition><v2_left offset="80px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note><v2_note refQuery="Storage Forecast"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Used in 12 Months: </staticValue></dataSource></v2_chartTextItem><v2_chartTextItem><dataSource><dataItemValue refDataItem="Used (TB) in 12 Months"/></dataSource><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note><v2_note refQuery="Storage Forecast"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Monthly Growth Rate: </staticValue></dataSource></v2_chartTextItem><v2_chartTextItem><dataSource><dataItemValue refDataItem="Effective Growth per Month"/></dataSource><style><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_bottom offset="120px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>One Month Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Daily Changes)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart14" refQuery="1 Month Trend">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat pattern="MM-dd"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Usable (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:650px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>One Year Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Monthly)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart15" refQuery="One Year Trend">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd/yy)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Usable (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:650px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Three Year Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Monthly)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart16" refQuery="Three Year Trend">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd/yy)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="solid"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#3399CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#3399CC"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineStyle="dot" lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#CCCCFF"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Usable (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:650px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Select Storage Device: </staticValue></dataSource><style><CSS value="font-weight:bold;color:gray"/></style></textItem></contents><style><CSS value="color:white;font-size:12pt;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><selectValue parameter="sArray" refQuery="Array Prompt" required="false" selectValueUI="radioGroup" autoSubmit="true"><useItem refDataItem="Array"><displayItem refDataItem="Array"/></useItem><style><CSS value="width:200px;height:600px;background-color:white"/></style></selectValue></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><promptButton type="next">
			<contents><textItem><dataSource><staticValue>Reset</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="padding-top:5px;padding-bottom:5px;padding-left:15px;background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;background-color:white;padding-top:5px;padding-left:5px;padding-right:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:15px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.5 NetApp Node Capacity Forecast and Trends</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Overall Capacity">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT DISTINCT
cap.StorageName as 'Storage Name',
cap.CapacityTB as 'Capacity (TB)',
cap.UsedCapacityTB as 'Used Capacity (TB)',
cap.volTB as 'Provisioned (TB)',
current.usedTB as 'Current Used (TB)',
cap.FullDate as 'Full Date'

FROM (

SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1) as 'StorageName',
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'FullDate',
	
	                  
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'CapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'UsedCapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'VolumeTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'InternalVolumeAllocatedCapacityTB', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',

ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024/1024, 2) AS volTB

	FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
) cap

JOIN

(


SELECT 	
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
			
		ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'UsedTB'
		
		
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk



WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.storage_dimension.id, dwh_capacity.storage_pool_dimension.id
) current ON current.storageid=cap.storageid AND current.poolid=cap.poolid







</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Current Used (TB)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL1].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL1].[Provisioned (TB)]</expression></dataItem><dataItem name="Subscription %"><expression>[Provisioned (TB)]/[Capacity (TB)]</expression></dataItem><dataItem name="Free Capacity (TB)" aggregate="total"><expression>[Capacity (TB)]-[Used Capacity (TB)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Max Date"><expression>maximum([Full Date] for report)</expression></dataItem><dataItem name="Current for Report" aggregate="total"><expression>if([Max Date]=[Full Date]) THEN ([Used Capacity (TB)]) ELSE (0)</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="Storage Forecast">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT DISTINCT
cap.StorageName as 'Storage Name',
cap.CapacityTB as 'Usable (TB)',
cap.UsedCapacityTB as 'Used (TB)',
cap.ProjectedCapacityTB as 'Forecast Usable (TB)',
cap.ProjectedUsedTB AS 'Forecast Used (TB)',
current.usedTB as 'Current Used (TB)',
cap.FullDate as 'Full Date'

FROM (

SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1) as 'StorageName',
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'FullDate',
	
	                  
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'CapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'UsedCapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	
                   NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'ProjectedCapacityTB',
	NULL AS 'ProjectedUsedTB'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
UNION
SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1) as 'StorageName',
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'FullDate',
	
	NULL AS 'Raw Capacity (TB)',
	NULL AS 'CapacityTB',
	NULL AS 'UsedCapacityTB',
	NULL AS 'Provisioned (TB)',
	NULL AS 'Volume Consumed Capacity (TB)',
	NULL AS 'Internal Volume Allocated Capacity (TB)',
	NULL AS 'Internal Volume Consumed Capacity (TB)',
	           

	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.rawcapacityMB)/1024/1024, 2) AS 'Projected Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.capacityMB)/1024/1024, 2) AS 'ProjectedCapacityTB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedCapacityMB)/1024/1024, 2) AS 'ProjectedUsedTB'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_future_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate ) cap

JOIN

(


SELECT 	
	dwh_capacity.storage_dimension.id as storageid,
	dwh_capacity.storage_pool_dimension.id as poolid,
			
		ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'UsedTB'
		
		
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND  	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk



WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.storage_dimension.id, dwh_capacity.storage_pool_dimension.id
) current ON current.storageid=cap.storageid AND current.poolid=cap.poolid







</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Forecast Usable (TB)"/><mdProjectedItem name="Forecast Used (TB)"/><mdProjectedItem name="Current Used (TB)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Usable (TB)" aggregate="total"><expression>[SQL3].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem name="Forecast Usable (TB)" aggregate="total"><expression>[SQL3].[Forecast Usable (TB)]</expression></dataItem><dataItem name="Forecast Used (TB)" aggregate="total"><expression>[SQL3].[Forecast Used (TB)]</expression></dataItem><dataItem name="Current Used (TB)" aggregate="minimum"><expression>[SQL3].[Current Used (TB)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL3].[Full Date]</expression></dataItem><dataItem name="Used (TB) in 12 Months" aggregate="total"><expression>if([Max Date]=[Full Date]) THEN ([Forecast Used (TB)]) ELSE (0)</expression></dataItem><dataItem name="Max Date"><expression>maximum([Full Date] for report)</expression></dataItem><dataItem name="Current for Report" aggregate="total"><expression>if([Max Date]=[Full Date]) THEN ([Current Used (TB)]) ELSE (0)</expression></dataItem><dataItem name="Effective Growth per Month" aggregate="total"><expression>([Used (TB) in 12 Months]-[Current for Report])/12</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="1 Month Trend">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1) as 'Storage Name',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Usable (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used (TB)',
	NULL AS 'Forecast Usable (TB)',
	NULL AS 'Forecast Used (TB)',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repday = 1


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 30 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.tier_dimension.tk, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Forecast Usable (TB)"/><mdProjectedItem name="Forecast Used (TB)"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL8].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL8].[Pool Name]</expression></dataItem><dataItem name="Full Date"><expression>[SQL8].[Full Date]</expression></dataItem><dataItem name="Usable (TB)" aggregate="total"><expression>[SQL8].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL8].[Used (TB)]</expression></dataItem><dataItem name="Forecast Usable (TB)"><expression>[SQL8].[Forecast Usable (TB)]</expression></dataItem><dataItem name="Forecast Used (TB)"><expression>[SQL8].[Forecast Used (TB)]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL8].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL8].[Cost]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="One Year Trend">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1) as 'Storage Name',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Usable (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used (TB)',
	NULL AS 'Forecast Usable (TB)',
	NULL AS 'Forecast Used (TB)',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repmonthorlatest = 1


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.tier_dimension.tk, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Forecast Usable (TB)"/><mdProjectedItem name="Forecast Used (TB)"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL9].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL9].[Pool Name]</expression></dataItem><dataItem name="Full Date"><expression>[SQL9].[Full Date]</expression></dataItem><dataItem name="Usable (TB)" aggregate="total"><expression>[SQL9].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL9].[Used (TB)]</expression></dataItem><dataItem name="Forecast Usable (TB)"><expression>[SQL9].[Forecast Usable (TB)]</expression></dataItem><dataItem name="Forecast Used (TB)"><expression>[SQL9].[Forecast Used (TB)]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL9].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL9].[Cost]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="Three Year Trend">
			<source>
				
			<sqlQuery name="SQL10" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1) as 'Storage Name',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Usable (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used (TB)',
	NULL AS 'Forecast Usable (TB)',
	NULL AS 'Forecast Used (TB)',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
AND	dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repmonthorlatest = 1


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 3 YEAR

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.tier_dimension.tk, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Forecast Usable (TB)"/><mdProjectedItem name="Forecast Used (TB)"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL10].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL10].[Pool Name]</expression></dataItem><dataItem name="Full Date"><expression>[SQL10].[Full Date]</expression></dataItem><dataItem name="Usable (TB)" aggregate="total"><expression>[SQL10].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL10].[Used (TB)]</expression></dataItem><dataItem name="Forecast Usable (TB)"><expression>[SQL10].[Forecast Usable (TB)]</expression></dataItem><dataItem name="Forecast Used (TB)"><expression>[SQL10].[Forecast Used (TB)]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL10].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL10].[Cost]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Storage Name]=?sArray?</filterExpression></detailFilter></detailFilters></query><query name="Array Prompt">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
SUBSTRING_INDEX(dwh_inventory.storage_pool.name, ':',1) as 'Array'

FROM dwh_inventory.storage
JOIN dwh_inventory.storage_pool 
ON dwh_inventory.storage_pool.storageid=dwh_inventory.storage.id
AND dwh_inventory.storage.manufacturer='netapp'

ORDER BY SUBSTRING_INDEX(dwh_inventory.storage_pool.name, ':',1)</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Array"><expression>[SQL2].[Array]</expression></dataItem></selection>
		</query></queries><reportVariables><reportVariable type="boolean" name="showLabel">
			<reportExpression>ParamDisplayValue('sArray') is not null</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables></report>